[index]

Line Text Chunk

Syntax

line <integer1> [to <integer2>]
{of | in} <expression> the <ordinal> line {of | in} <expression>

Description

The line chunk yields a substring of an expression by extracting a specified line or lines from the expression. Lines are delimited by returns. The expression can be any valid text string, including a container reference, a property reference, a function that returns text, a literal string, or a combination of these.

Notes

You can specify ranges of cells, the following example: line 1 to 2 of field "Inventory" You can use text chunk expressions with tabular chunk expressions by enclosing the tabular chunk expression in parentheses, as in the following example: put line 1 of (row 1 of pickList 3) As with all chunk expressions, you can specify chunks of chunks. Attention: You can use a combination of text and tabular chunk expressions to retrieve values, but not to insert values into containers.

Examples

The following examples demonstrate various line text chunk expressions and the values that they return. For the examples, assume these conditions: Expression: line 1 of "Hello" Result: Hello Expression: line 2 to 3 of my_variable Result: green blue Expression: char 1 to 3 of line 2 of my_variable Result: gre Expression: the last line in my_variable
This text has been mechanically extracted from the Oracle Media Objects 1.0.4.9 MediaTalk Reference, © 1995 Oracle Corporation, and is provided here solely for educational/historical purposes.